SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470820 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470820 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601919,467699,144342,1020474,367140,789961,1026211,871047,137399,593709,15793,583048,348138,519316,884064,749220,193562,89116,386646,75198,1038896,470971,724398,959506,909250,811211,478516,992338,225450,421076,756648,824834,954155,409401,771287,59162,143770,662379,324414,264443,784421,919834,979831,1014827,360505,692974,536016,529482,392882,879228,1012865,515699,733749,932964,969493,953238,271082,571715,500567,24315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]