SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410971 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410971 [ RunTime:0.006683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145771,27364,480091,600329,28583,808508,965153,48037,586195,81267,548371,299852,604461,408838,877299,831138,1005940,77393,298748,729609,1009720,562779,502729,913735,546885,210900,928408,594412,165523,62352,609102,693621,175308,757822,988489,1001764,235369,33847,880831,639556,623567,139355,413876,612131,541221,985487,224230,1031621,1033552,733436,166783,325349,769138,335251,884682,655847,710521,36587,989413,716835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000906s ]