SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68102 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68102 [ RunTime:0.003844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13857,271019,201646,778747,203753,955459,884735,666335,481065,363628,74763,402669,180300,893594,301728,659931,1035399,112932,963999,701266,790603,151943,987809,958561,68641,506619,644138,251448,329480,353270,328207,104160,815885,621525,895252,385682,200114,514214,520503,976754,416900,232841,202435,491561,900676,686991,460134,599876,420780,1004095,693382,753558,665334,97680,553022,866082,73238,454739,59040,220885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004611s ]