SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205491 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205491 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803207,839157,23858,968783,745167,85518,908800,4087,1009060,324442,653847,359561,428196,427693,932911,186998,35982,759952,525595,292651,527514,987441,467604,673654,717221,940918,328804,662995,517024,275127,513112,877700,631608,241007,291604,75465,819336,628176,1007295,913052,381094,30782,844085,558007,471424,83327,689231,1015336,622627,271715,407664,886293,453446,721180,207286,116637,697124,33565,434808,868164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]