SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 679610 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 679610 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032269,221038,41341,145932,408758,772720,521178,381552,500403,291839,23320,559095,109875,916277,365002,756595,644148,811526,496297,736869,895476,480624,384315,867006,775986,291167,93649,829966,309941,61319,684881,335161,907311,476607,573812,405022,518365,151397,941744,766142,768834,385935,577547,146102,526215,90060,510101,74048,398434,236178,992912,580950,830359,954650,347260,93329,921461,268030,447978,338281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 679610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 679610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]