SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431410 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431410 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430959,959810,161605,329582,920867,1005230,297241,967746,598341,64085,463574,917897,708084,725294,41027,132651,225389,412934,1006901,676049,117995,453056,1033159,674549,62798,293659,14617,564983,739260,677922,91341,936798,165908,723801,375995,1000216,41179,993048,590157,200493,923823,976435,586338,820670,526724,1017740,861702,126986,479828,621015,495767,725979,849251,727645,926776,936721,645687,66429,280919,811825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]