SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390091 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390091 [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796561,890532,123832,877003,405475,182337,731973,477280,896515,501131,815917,94092,746758,267658,373050,376022,710292,886734,785894,147775,183425,350063,902246,879801,581205,258673,698875,596657,408032,934257,1014035,816611,949529,789557,968917,211037,814340,334916,243531,126783,173370,74378,66906,574371,522132,727469,737448,111634,895767,247136,909443,454439,647974,1004941,981065,480256,709999,525203,983986,1012247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]