SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506610 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506610 [ RunTime:0.003953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488396,735879,568367,415018,399134,331866,604142,811347,595972,251484,865263,930627,293093,605662,72003,772971,39835,309265,835343,705336,465962,461141,247342,899454,713283,179362,321080,552460,112468,549688,531455,685421,643366,208396,1014624,829680,771399,882915,675578,885011,371617,558503,454165,369932,837543,905818,222013,965302,471363,253769,495531,628287,183958,570800,672744,198099,847558,800277,920329,239691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]