SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504225 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504225 [ RunTime:0.003298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803833,906266,743604,318350,240859,346585,318398,458852,140925,428714,860790,80005,391138,138449,153915,1031581,485549,43298,136772,269352,777560,769142,883173,1017228,587851,393842,57054,304187,311659,316953,135691,133137,499853,532419,329598,1043057,598383,370771,729039,736392,101402,880045,336318,854105,651666,393923,590136,1010316,681168,322703,854709,1022320,774608,829986,115795,655549,340551,456623,1021986,279420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]