SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196810 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196810 [ RunTime:0.003956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856622,71217,526620,1024452,912886,476253,233902,701023,236575,412126,270894,667393,397560,477012,85172,743236,125897,990297,647221,361932,87987,531403,674048,632251,93883,462314,47780,76668,47379,927067,588703,228344,65249,341133,390476,431009,1002716,593455,561671,164355,137279,452704,947526,678190,531616,717010,642355,702455,164495,174690,443720,289346,978998,805532,904074,645401,101251,314209,137670,79745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]