SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295224 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295224 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542304,870517,81744,471780,979776,285835,1015846,403289,349420,419161,312134,90279,67025,185300,341007,276377,406721,82842,480991,407763,560602,81548,970116,820976,591246,3807,311201,280703,312672,532262,957954,750522,710371,552866,809735,295456,535083,143613,791619,503700,304258,12490,106180,636091,873638,253140,1024725,52928,977797,929467,473522,840383,121349,394901,370526,636490,1007048,957762,671163,732819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]