SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002309 LIMIT 1 [ RunTime:0.000767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002309 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582805,116996,252286,838091,916484,484172,730458,379095,107545,768650,942630,843267,344807,492411,19717,319192,933996,154235,408228,121385,626888,991016,705696,484666,239772,602389,500811,764798,922235,758861,690901,260644,1010895,489539,1025970,513080,416325,58248,947706,267931,581237,796914,937930,452199,887953,766301,41793,1038088,554090,410172,405953,775263,533483,906601,120743,1006261,345387,41458,282761,581222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]