SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488504 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488504 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791454,277035,107417,426622,1032658,891323,637427,646348,989259,987657,337222,655107,72233,749383,1031238,39253,261160,425048,920500,936650,643978,7023,347167,175492,109029,25443,849175,1031270,587385,634866,846012,309317,764922,121696,506534,199691,318787,337470,881561,846204,450406,958101,858801,660928,95161,469183,253947,854880,579735,536453,314781,547652,754848,510801,62831,978831,989818,678596,671500,643959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]