SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314081 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314081 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947520,676356,873003,326736,137522,796437,644547,808265,599288,677761,724373,689443,847753,818295,578433,171240,1036306,424551,818022,545608,529592,593309,531173,71924,2129,776635,1003191,658633,1020784,733370,352504,375152,769800,993735,955909,263771,787685,273588,699224,913628,760800,1025605,456902,356310,640087,764852,187770,673477,298585,383033,579447,101002,9254,371981,466791,199082,487716,478624,978246,804790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]