SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507501 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507501 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663230,957744,414425,140321,425853,887680,259380,680332,1041712,661696,871382,546706,944837,251463,669642,833524,213848,674096,845936,126672,881803,786482,908260,692783,41006,153655,184396,349978,391371,397819,197575,220390,732797,609333,698141,275632,547255,778011,860983,273067,947846,91387,138402,1007554,1020851,581750,675036,325796,657816,881899,50143,563085,384439,289588,172013,265263,1001676,830171,854631,105781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]