SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403781 LIMIT 1 [ RunTime:0.001346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403781 [ RunTime:0.002625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349890,502744,420488,854351,468779,1002154,51921,435216,230615,153996,623843,757633,34957,817389,209518,555380,699801,962834,409612,701549,454194,1000017,835200,854125,397005,251325,252222,627192,245923,651779,281583,866193,935260,983643,392758,973903,404930,425307,872532,803358,1025310,1046661,435118,661706,98651,1009942,137548,80888,754966,818940,719906,983122,568348,790893,714476,454533,72310,432430,922991,681760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002106s ]