SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341839 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341839 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829588,286623,54869,869410,812929,215139,799195,774115,798640,602173,60213,11005,613910,457219,509175,1014031,424969,264050,593015,991328,848918,417461,718692,883798,115755,498628,50652,163497,306886,894906,350117,776180,192802,658033,161238,410977,676386,55868,911945,283509,13947,363172,376312,127755,838425,512179,738225,491889,589206,879693,177294,818385,172745,416270,515880,992776,851208,1036473,331036,812745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]