SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544535 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544535 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205416,323681,142570,823660,634516,311522,106572,702979,63877,960557,145744,216895,48319,1024611,261282,80188,518778,1047423,872058,163481,672456,658283,172134,960211,193956,717619,183340,316937,323892,598382,690108,871549,395755,620863,565433,620214,409856,466752,773733,946747,836533,878169,259425,368643,130083,262234,646225,845878,790712,136003,502279,747182,796759,50145,601536,965313,315381,809241,806436,510228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]