SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454049 LIMIT 1 [ RunTime:0.005472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454049 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510731,651927,154610,423112,256634,519349,824594,471436,368249,389208,931716,511332,1047214,185184,552036,220083,191359,1012144,672821,140422,735879,593917,239636,544794,848208,103516,246068,682246,95486,903604,485969,457726,661830,98392,518745,713916,799597,738491,914780,275058,20447,851395,790329,851836,995842,638202,198459,176976,158795,291718,745572,628830,978339,208166,800536,849530,330253,742929,877407,58162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]