SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33068 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33068 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996941,341062,921406,506480,851402,235609,597079,129825,940128,556566,506572,808464,829288,276801,15289,534308,7371,428043,456657,752203,901257,772432,878328,22078,487982,876817,304189,367943,286138,642294,90840,344544,592716,162591,666130,978271,33602,388735,316359,198021,379987,210068,153459,333740,866583,435834,393101,982291,848050,441248,540660,835498,91447,680433,458454,547972,976118,501837,799872,23390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]