SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249553 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249553 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209482,836918,693611,325433,834836,1043312,845338,175399,991335,709452,1018865,64221,827098,7965,882365,824249,193043,356939,178725,943894,296003,20765,994682,252795,371459,46885,898360,74852,706771,528901,482278,540480,775572,195790,151010,388315,573267,5790,920038,197752,417664,221159,6529,46975,22401,163512,428913,381904,453271,104273,1026562,987868,396093,172809,663269,658055,524524,869770,49206,352884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]