SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039774 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039774 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320351,112772,920347,113159,309836,201530,123106,355801,561467,559957,280717,368811,527992,11098,673609,512200,963912,350727,985292,784129,846064,656478,957478,159322,184294,964452,771793,995158,1032886,516652,396635,825996,297139,600226,491335,137842,823436,739409,755287,265188,978243,808134,568534,333905,227599,72768,125480,772747,884422,172214,994280,36057,156441,189347,808030,46995,812353,26601,637813,396748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]