SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320481 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320481 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949890,910827,191801,480547,449726,549689,422611,180620,894660,276113,525121,982439,623892,956974,151108,479187,56432,500417,800686,38650,401481,116293,209861,344555,591798,732383,824560,151771,197264,1042017,298499,150615,369968,368483,405390,128491,182852,28564,188453,431168,990121,737622,876911,512343,51074,530246,980062,1028132,584906,352315,352314,966702,358506,624288,201564,438545,903400,251415,498349,772170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]