SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512100 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512100 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868332,598844,1003254,1011629,969206,449113,395714,983668,401303,561906,439477,241589,780173,676282,106179,230850,124614,4780,664586,86101,403451,1034778,184527,378893,233856,71432,503388,897228,148534,323733,916733,338733,493445,194099,712140,929305,441642,986119,459014,1047292,997946,728692,748170,115772,976801,671459,813917,911166,196501,90492,49998,472377,51007,41678,535011,80140,79616,529731,552659,88061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]