SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575099 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575099 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40810,782254,391215,675856,354723,13475,117671,565624,715478,56329,278757,1024980,175312,130229,751352,615099,416478,237730,698339,627533,153374,261238,306493,681364,37747,828195,921693,165811,562258,850496,163756,15735,760976,131441,40737,335979,919916,866142,980189,690968,550129,593549,722404,641144,723978,682945,231153,272327,114411,849219,905864,793675,825011,513830,696639,1020839,760391,748857,660390,550962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]