SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479080 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479080 [ RunTime:0.006017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496483,275001,290005,308072,1018088,435620,462095,959838,137560,837770,197338,497487,637233,792310,1014657,317133,593445,368587,506983,337685,307313,859861,535974,682910,483470,917940,420042,80950,563133,873435,425967,397532,113975,696329,12921,331903,921979,604107,207065,450190,210308,787452,215343,375096,822114,942075,340716,314755,191208,659831,310561,523959,920926,128439,18637,946653,155108,605860,351554,236376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]