SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5836 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5836 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990379,530478,241179,28721,456218,709493,909447,762871,418074,37818,59371,321145,871902,217397,459071,702129,838290,119228,179428,260160,346602,379590,840995,222395,422014,582482,603822,505694,446334,470738,126514,11549,984430,340559,749275,140531,13132,195375,13989,915633,488782,720924,500688,823295,398387,646404,1012983,656265,272460,940215,387866,853326,794834,79867,336597,497784,677663,969173,1025090,109411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]