SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546193 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546193 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992548,360357,492392,269244,568456,55751,695726,473982,704801,880034,336102,432824,733018,297475,28718,568562,519798,698688,511235,1023720,608307,527986,164520,145178,489184,311230,273585,852978,122700,934728,1029220,296157,152419,1030462,53127,508039,667326,857428,1010305,693205,952988,430776,90117,165583,83097,521780,689785,869782,829648,977997,188545,38857,882234,814007,834921,788422,497860,399206,248443,890564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]