SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501553 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501553 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744612,617970,1034020,202953,687236,591694,328762,724047,942108,302197,701681,301821,472489,254168,761590,489420,538989,864050,591864,519357,432467,1043191,801221,810711,858637,751315,300284,1006272,1043559,933800,315303,1006304,529862,987732,399387,341531,798668,69812,9846,896793,424208,621448,923658,396119,282007,221671,881085,776954,195296,85343,853705,778329,1047988,53739,935886,430581,990663,587739,994270,604002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002791s ]