SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037238 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037238 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588370,710303,780855,239036,990657,276074,258752,991782,630874,373464,844949,850525,531031,573109,139112,605393,427214,1031377,648304,660554,882414,1023191,865806,145920,750973,480599,652644,639344,879979,291027,92255,444370,261866,798955,487175,664320,312507,724919,544605,646979,667928,517149,415362,560443,924004,266770,659875,477261,433435,353866,309959,486217,333808,46950,215290,844204,594867,870236,720661,512709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]