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` = 972914 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972914 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023774,283021,1010261,226075,490393,982921,24335,19726,597339,913476,398552,553245,157874,383589,170289,223241,547949,826985,571148,690475,532604,763046,514759,548820,356408,509307,282078,440157,801887,459664,685907,550424,946441,425356,929829,671871,233186,934833,898299,222192,497675,700374,68449,381011,229607,435873,503351,492037,741503,602527,655466,853217,706526,122632,688148,923611,718179,417990,802259,684029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]