SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417161 LIMIT 1 [ RunTime:0.000974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417161 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913747,637463,257094,234842,278780,544322,913218,449354,596073,196437,761340,967382,97985,1011672,461181,507648,1046515,359364,415436,345514,1000732,170586,159586,399683,711015,811976,631444,708921,93699,192377,88867,118111,159843,1024554,1012803,569364,71852,69994,296264,894640,264419,137677,404979,1004259,831123,270669,402837,400367,207519,199082,226562,145953,771428,972897,1021277,868735,849075,240725,299063,822005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]