SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501308 LIMIT 1 [ RunTime:0.000828s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501308 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774515,665388,35787,166361,908598,756556,172600,688106,675796,940436,242723,609001,377213,646803,96046,691760,444008,561032,902099,379200,755461,319088,426710,981855,533272,931492,942771,915997,459754,570377,817863,280831,128595,804441,676100,638771,127660,768616,803918,940786,18822,743348,679582,665458,818010,405259,450254,213868,890228,699381,204154,65141,840470,180755,368438,526077,793653,224673,464295,205671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001243s ]