SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314750 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314750 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513934,118621,106979,77792,786854,540814,860988,189926,821421,851044,557995,653714,289124,582452,366491,613230,193050,521616,1027397,641868,243215,902710,584994,190667,569225,763817,923746,807986,277040,381998,585328,760887,716040,883070,985582,491087,195405,460868,363873,75544,539882,374678,395319,173110,902914,188635,35972,830213,508587,122638,1030932,782595,21739,291763,1020000,337166,587583,443002,167441,328302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]