SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581780 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581780 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162851,1019000,400218,541215,315615,45302,761413,777806,832207,271981,821411,865363,620452,552294,623282,646327,157354,70093,505653,141831,815678,498189,935345,780876,890721,884427,577963,412838,644832,543305,396174,793352,334335,604528,674092,197065,947559,320960,744433,671520,1039290,764016,736342,478993,449548,411471,435383,968078,870977,176872,855077,265579,739849,36785,636755,764111,986956,1027627,500223,496888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]