SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580810 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580810 [ RunTime:0.002865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809659,58491,577070,1017049,59211,605450,440059,344329,152831,678070,600080,405143,142859,563328,642811,430833,1021976,494986,287989,602594,701263,495332,637261,820946,220926,568713,166642,853712,891630,273060,159990,667262,299321,88757,414375,814466,236174,786837,415643,174845,135762,502584,575493,90749,888149,203534,987840,347711,306923,359881,964817,715613,910080,724618,223901,521468,682174,206595,351285,15297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]