SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509655 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509655 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210742,95825,532064,549005,102021,126566,974166,463408,895370,281924,382694,61493,959310,936512,233030,401919,465459,999014,338676,47546,483019,442640,223727,507668,207593,31557,545772,170735,243972,276847,121576,705822,371623,893053,868334,444960,380085,942954,625872,534414,839710,1005674,900874,843464,28715,502934,61214,98212,653971,824402,849873,507664,640688,559986,714864,696331,1007427,610670,808242,989595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]