SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200836 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200836 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684872,183058,608317,856354,746766,891967,418765,1020510,25210,315192,116309,784297,323437,529813,860379,940921,615391,537566,687598,802043,97574,1000917,996723,1028337,532426,186917,672789,479162,406117,520930,376907,107105,659492,206684,89399,432205,4886,117914,673104,614910,549385,83648,718785,261113,494399,157202,655187,289393,377984,196886,1036574,472649,919219,714504,988013,879653,503343,662626,444447,176423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]