SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401970 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401970 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905741,829244,806417,375930,236935,478212,931354,812237,58994,169908,482511,673866,62731,723127,521970,780791,307693,783845,58889,905756,900169,513645,834442,91863,100287,858358,931138,366085,483069,969369,190332,945824,549479,643277,440038,347171,696189,1007184,710360,350257,307012,349828,523988,1815,854840,14853,728524,962455,58622,930176,876032,649227,116625,935450,369149,605097,381681,169557,470159,495983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]