SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801056 LIMIT 1 [ RunTime:0.004156s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801056 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454011,330396,319774,685947,674706,947163,469499,13285,242993,137004,452425,490121,220444,889625,511030,392250,418506,272899,120975,994748,97114,107901,388123,530823,770738,911036,1039316,73623,602919,907520,1035469,941398,103583,127328,891450,889744,58086,470928,704860,863832,272723,550976,189934,724276,590262,948227,581501,1039142,627179,713899,466317,746210,327292,957308,413198,896240,564585,105869,402813,181194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003268s ]