SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493813 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493813 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628605,294565,115889,38514,408908,372596,294074,510267,96472,603879,1040137,1012365,510169,408102,166826,630275,603103,386231,607946,15356,347500,530417,228555,329840,89839,639469,329211,785608,661790,492317,109211,415591,509537,804959,433477,661217,322305,738173,563218,708177,820179,283271,212707,922750,228490,221315,1008083,436601,158238,586437,475821,690492,385004,402749,336274,145720,853111,345219,760083,831576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]