SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409091 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409091 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214787,334555,746383,905048,190508,876568,902167,535922,34521,31674,38597,610449,816826,945822,807286,1009001,15083,552209,880012,95850,715205,510379,926417,605286,787389,772990,569602,682899,297034,711203,851886,594195,193073,335925,692788,87378,789051,161585,382563,317123,678098,234217,284734,142735,118586,220720,501989,78063,970877,418286,75,465147,731989,210221,163304,618294,392798,61347,975448,388137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]