SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524083 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524083 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627784,336918,924924,698702,674313,887560,98744,214031,711082,975859,31834,592077,274996,528050,749252,920690,768737,954491,158468,273431,530803,201089,319939,719319,167264,1003312,1048915,470522,297367,537301,845319,827294,750678,1030308,334181,179543,296142,892453,957983,291517,256023,288462,47500,617347,1003654,740900,374682,1029030,608055,598609,1008231,174709,755773,153117,463791,35959,310467,525315,181958,604718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]