SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036685 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036685 [ RunTime:0.004013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854532,968204,481083,85058,831911,536574,737352,343614,333271,341397,247456,858938,263428,613803,1027502,356500,54641,195514,267436,534568,827012,454277,1039343,215535,576393,432786,451951,155190,425574,261012,27222,288082,976870,671463,698947,316063,725632,958239,886655,445623,122646,561678,992295,208189,337871,715488,396575,946661,758823,696265,765181,261652,634213,241689,94581,555795,654013,665891,907377,374569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]