SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555796 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555796 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812814,89475,38680,444260,149010,87861,62950,628012,434452,2404,184408,423093,877504,889022,376076,32317,558235,978313,528176,252157,367030,29785,563272,234130,371157,955667,937376,262944,355002,727726,92037,711295,966621,225199,700570,1005588,27219,793489,979638,853244,721731,333968,521718,723314,806810,787807,264526,963686,833466,245454,324865,147781,73862,548402,526540,762895,630625,36781,1048088,1009382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]