SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514793 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514793 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179028,428606,422912,517835,50045,914985,702499,204816,615448,921416,622419,412947,936449,522549,485241,982720,543815,214719,502649,22901,161181,142508,175646,206733,210295,349687,232310,21146,571355,42261,1022658,945889,430801,353619,716022,520778,76800,135410,179691,868305,905455,594442,995661,505195,322633,271347,409626,472023,835417,575807,446943,691021,1009179,182478,498067,96313,1034645,248800,305238,540652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]