SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104613 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104613 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402469,558443,646552,438957,839518,832264,1012275,462620,682651,1041942,980953,976977,260778,288641,803320,833775,296664,660715,526499,1027479,965947,864982,74465,855773,297999,64842,698926,797573,125891,953368,225111,807235,74422,973652,209925,1046382,917988,329289,176526,489142,524541,658516,253118,761120,907091,186384,482024,459807,707661,625716,550727,176711,424789,53581,6166,120594,922320,590014,552858,938893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]