SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554710 LIMIT 1 [ RunTime:0.002410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554710 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593679,873910,650217,365502,269613,722524,1031229,61462,516128,483363,614808,699960,283252,572243,675904,439152,225755,975444,680983,872915,613871,1041878,849305,124285,999511,1022504,599551,876746,508902,612665,394902,95013,436968,944171,604017,213971,885284,262225,116283,130653,824651,641843,1008969,907298,961626,348469,457711,796806,929904,1012613,56066,456607,1043266,302874,593978,914930,183452,818800,536995,1027439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]