SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412605 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412605 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593877,784119,411023,629893,130837,623543,614970,503021,375431,961320,808708,573349,383771,661971,144203,500857,910732,420888,142181,893200,302931,216395,283920,233281,30501,810140,872390,1038202,589632,157404,592274,729847,567501,1021045,219158,972688,1010817,515280,663124,234394,796304,252907,494297,909966,943187,982313,437550,151543,980545,128667,487009,164336,926408,385988,667787,220123,189477,317285,643740,85183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]