SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014795 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014795 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935225,375364,402650,838868,999822,244868,245258,780185,545247,945288,522748,1003188,542175,908214,438271,65060,631990,138821,663211,14016,712158,80732,390077,890749,56918,892399,529605,87063,1025614,617429,391170,637653,995306,720003,186250,613944,277763,94433,546526,874257,416218,177179,358683,857468,854192,126098,69552,96127,555423,720623,934101,791173,382500,748228,1012513,290822,542024,365060,326150,267288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]