SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3417 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3417 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159283,984668,58603,396022,130414,860553,659226,546041,922320,360669,696489,525461,676408,698090,672876,255612,582008,951428,900918,620385,344106,750986,34059,943771,601494,10262,7444,350764,836669,31117,219087,750329,882999,844955,221035,3859,372608,698104,717940,631216,681020,527815,266404,826183,706962,845076,660287,313143,661719,92139,844892,134543,497532,47112,592340,387049,1003482,525364,670748,753842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]