SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331017 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331017 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693434,909887,944128,250312,878816,375832,1026078,731451,694963,727662,707505,1043822,145248,705893,76000,415980,900279,254365,774591,322465,944690,226043,126483,470209,112525,261450,440139,1039295,675986,697837,623090,575293,719619,871342,190952,480626,436885,970417,751339,373433,961842,6004,1046840,271984,716298,144784,515766,98438,700908,740233,943320,580943,40444,442733,79253,230193,669199,719563,499001,774590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]