SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805414 LIMIT 1 [ RunTime:0.002379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805414 [ RunTime:0.003322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404603,69592,557129,1006879,72768,251905,633636,265263,1004536,223050,524842,835336,735830,919739,359502,920187,491293,92953,601838,174986,290372,292785,498765,612368,874874,884814,344735,997818,381342,114620,70923,78368,771600,378051,998696,331651,581899,958783,737258,277878,318592,732298,265574,271793,467340,647176,806942,878155,756754,43421,897935,219697,649311,877329,1029686,72070,980324,342121,28875,594173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]