SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980908 LIMIT 1 [ RunTime:0.001793s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980908 [ RunTime:0.004162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777243,459628,36592,136094,754850,553078,733027,1003727,778131,362592,322525,58936,749694,923991,209826,550432,178073,109176,406887,142774,118596,731913,304284,18738,977158,977672,993136,221674,288752,552409,1005135,730662,373840,980252,737050,541695,157815,422865,922972,177891,674481,153477,4010,757525,420340,290976,647234,971672,811740,461584,444168,705723,489919,562626,1022498,312507,928026,235201,199087,117267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]