SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391217 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391217 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59926,454667,136092,256690,524555,374333,890865,162525,750720,782693,1030577,939780,541809,167857,698766,172458,645157,847249,719689,1035035,108013,474848,343025,430119,456946,402128,940018,609855,60405,595215,978745,855171,125572,797379,465612,123058,782883,1003875,170565,185449,330916,335507,1013054,295548,887680,536237,700508,986524,233118,1007877,702425,10551,120007,451641,714466,906294,482794,869588,267706,906521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]