SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385568 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385568 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409479,820468,228393,499434,710186,922544,244407,683,242277,604989,872047,957650,688770,78613,348488,639178,332983,96811,382449,901718,27926,416650,725562,951287,739076,1014353,517351,94200,567199,853768,181274,209629,879162,339981,317381,146489,586343,532488,545958,716561,348913,60142,81340,349158,820531,384228,980649,524065,297540,558278,168740,231285,87421,588223,868447,972213,819415,363195,1032587,445953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]