SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045100 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045100 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655039,118105,1018022,478397,339304,306525,92386,316763,910858,229022,398066,638640,717651,945330,526096,55640,473752,906534,173079,420830,987760,713362,195552,246031,673378,357984,791619,673787,277690,579273,80505,303706,484391,611241,927890,168761,856863,249828,475983,647778,570299,73175,735954,249985,933122,1004641,422677,240668,268088,2462,973064,199953,116993,388378,703955,471355,128676,192167,542498,374160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]