SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509838 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509838 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557856,871967,384041,64785,647193,680599,814807,610274,770838,327975,405550,837370,13729,961533,195716,771330,820917,713043,365800,668586,22110,342291,101837,344719,1010415,992831,590995,459556,68354,215485,950412,549131,542744,166314,350459,408942,289236,172109,264278,706028,212209,318898,749735,108381,1012910,989321,450999,758252,719616,822749,561684,616257,6565,543637,799359,807932,41784,572182,121650,811064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]