SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581311 LIMIT 1 [ RunTime:0.004151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581311 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896567,135488,204335,366181,842602,689349,846236,771729,433491,603066,295723,1020626,270162,56681,1010902,352332,102863,517107,313419,872392,814642,573933,588001,872283,37668,441962,146690,782990,853586,157750,719564,430049,511228,648563,65047,716804,1005864,436602,203020,303556,297533,374949,127656,271108,132868,80250,649475,198609,806403,885188,891880,27830,210493,733999,895256,27638,582025,526171,939224,28439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000976s ]