SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710912 LIMIT 1 [ RunTime:0.001305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710912 [ RunTime:0.002560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043344,105123,110636,426081,687961,772759,734387,207081,54177,529021,259250,87376,185040,15210,832169,946113,361416,690087,652493,698037,333837,685484,885385,233017,958295,985072,158195,405399,514899,508221,933643,519398,401222,787056,296680,816854,370243,260210,975522,64903,549465,817653,86717,590995,311975,232035,320554,469999,24000,544934,881089,1001357,431168,910078,973414,566385,1038705,596499,561263,450868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]