SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417061 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417061 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037547,812655,377343,553030,640639,720330,326800,364490,942689,767781,687240,969602,651804,599573,177797,488143,845283,1024010,1015066,379285,474603,393710,596662,8966,998795,71160,784929,301281,1018275,883181,954155,479698,838488,859184,652588,928478,611494,741080,469976,7682,685243,29288,584007,315399,730064,786152,742622,688102,17694,400545,902853,940400,456403,975854,1015058,592388,199383,1021723,429077,12551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]