SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001471 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001471 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573692,932168,987939,341180,345237,579931,880816,94095,17865,911206,355445,682452,289801,489476,577533,367457,196815,911421,157235,862705,574031,230117,235115,656838,757278,420144,952243,935354,459447,29545,1007606,334820,117309,4392,647548,923399,190582,985550,770786,154216,475966,646022,613140,126568,1015092,520515,503416,801179,724277,327334,365924,539147,34848,752392,146504,909241,763621,79072,38707,941813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]