SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415681 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415681 [ RunTime:0.003722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381483,449129,590178,741451,657160,6913,226241,742997,981766,713413,606485,109169,177587,718656,128123,751964,749452,128438,380217,123865,717470,416874,320782,180792,1031464,292211,524441,749199,949665,172384,908491,105287,215110,519947,578843,236281,230397,658967,616888,541083,1039626,273485,860790,94994,582796,454718,679926,506748,92175,910526,925722,193841,343271,728284,513965,860921,641168,895869,326386,115344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]