SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293817 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293817 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752710,61855,938523,841975,739707,1040862,123556,550503,675512,727099,361459,947698,453201,663683,642611,765899,1008125,712744,938574,291015,253831,802157,968203,715000,728360,774802,463193,1007544,424890,103471,366645,230086,644374,304831,429987,644571,1010125,863636,657497,235386,175487,927944,270667,389591,551667,469620,828074,143357,760470,20917,571390,381908,941005,974118,418242,1041747,36441,126425,1025372,1016048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001639s ]